SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140104 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140104 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29757,541937,315409,414670,206382,672795,260616,951041,849200,576699,973536,1023002,527331,472142,62824,533882,939084,859081,635946,33681,431179,778176,207830,125378,884037,444804,203771,695772,1000804,516386,936068,739789,131575,317778,709025,19457,525030,40303,199863,822816,27747,103167,908793,835398,357295,851648,952546,631271,274528,166797,518123,778941,415596,358135,558456,31244,37671,907226,66643,380334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]