SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003462 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003462 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631756,864355,348191,1030991,163948,698327,964554,977035,247380,120242,761725,746051,1027013,335932,554884,526873,384644,1006126,128211,423179,760061,655259,811829,328269,501724,448292,840113,1013363,642844,356825,588776,459575,434520,159880,466296,884358,109081,515870,866513,985651,253532,963080,67833,888132,189975,680991,277780,484752,545742,724818,847699,321958,709173,35710,1027745,236528,693131,141051,741126,1024876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000791s ]