SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420087 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420087 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89656,985314,288944,6769,955302,886142,290937,751603,334657,743528,363360,593447,1023551,365393,731679,29837,304001,792094,748510,661682,306194,239731,327689,262550,63473,650764,829742,531046,211381,521854,586211,241579,439755,1045702,220826,1010245,329028,242079,787755,52724,562119,774898,859575,390700,88455,584715,684080,843398,572414,472288,595221,416422,137103,451474,433106,563763,858776,414876,776949,217405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]