SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575152 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575152 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048113,173942,307004,202196,630471,188883,810175,54304,519687,551793,60017,808855,9781,635987,881704,1025141,386098,85182,448463,98960,2730,58854,656117,152186,571146,5085,629550,1006837,77032,172665,681590,781785,266633,303086,632902,227984,484553,574885,219127,364043,142000,209595,469140,852608,708883,35735,316553,377064,111774,365413,338398,245625,783173,1045221,612471,967329,231725,397233,645445,563547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]