SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307004 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307004 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008111,180443,1033624,163901,585917,515620,937261,200862,197232,200891,297211,948421,43519,107181,482081,248326,77987,998999,844825,358639,531269,896957,527263,19220,765503,310801,559918,1014180,539509,422071,586699,500193,752795,564475,133446,278734,695387,703258,879643,118332,234478,501984,377208,12063,1039802,761543,290087,76196,76418,156475,114543,263203,313961,342909,829243,501915,569978,577984,669399,1025037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]