SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190410 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190410 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708962,795887,96697,50687,722144,791158,486172,288983,426054,952783,332926,669145,739469,1002966,692376,412720,296716,376861,28113,538756,894068,430638,199725,859547,747092,88859,413615,246711,973277,178991,282287,13135,679831,6288,797793,810153,305542,1038896,269348,375978,539664,982598,224148,707785,601757,728603,976145,851492,356676,406547,111614,138618,857365,524307,563728,881273,1016701,702135,121613,395708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000794s ]