SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538918 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538918 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013286,173419,805754,929275,1041144,1034042,879048,1024434,460475,491336,284141,958725,428245,666845,18758,413700,509235,268749,658838,565777,1042189,643458,152696,817915,459269,721218,658634,212928,945942,161626,10767,966019,420655,839215,608030,670779,585334,748441,437762,727323,758220,255383,931198,819774,322263,908238,441269,776867,602723,1007691,30617,166755,219227,991519,941538,1011261,1045104,518317,665482,331342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]