SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107582 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107582 [ RunTime:0.002250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365891,171067,7347,147625,106475,123794,878669,313657,205980,658580,959892,75018,155199,1029660,522708,747398,460301,485545,542493,1041931,109035,315418,305257,919530,692453,686174,867621,473636,420874,917021,356237,874602,833205,910811,452305,3004,680969,570853,731553,73972,331569,844973,1004802,78489,673583,664576,900182,88640,917019,172329,594077,160243,407128,419714,1028439,70954,690266,72018,685191,1047134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]