SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28100 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28100 [ RunTime:0.001449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813582,1036828,218046,112433,765198,758245,991950,550260,615126,217686,904437,962555,949877,437149,417917,938771,215847,1031492,427477,93481,9585,350560,102593,613372,364749,736219,927039,263736,59067,879246,394939,805920,772965,632704,228907,19649,27522,405727,25563,64492,752672,395075,635572,938241,615064,545234,977281,614650,18140,386426,157875,886366,787603,5381,171143,871,361390,380181,286552,897646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]