SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19545 LIMIT 1 [ RunTime:0.003229s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19545 [ RunTime:0.003997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316421,667782,859916,570447,1022085,374368,314070,443244,908923,193775,796927,658890,106571,395767,1004932,1002513,906853,737359,804476,764822,915392,571893,810979,352428,336493,329108,409875,681063,729737,991395,834469,706938,428356,565184,93985,653250,722478,530904,914090,475991,1025678,853674,1035198,355719,347285,5125,999258,832400,595950,779257,964695,494031,577453,684030,796238,501285,681471,143424,88594,294504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]