SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348511 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348511 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1963,507991,39821,921091,171974,590561,745547,865175,290033,953301,489796,315469,450942,467353,10690,746042,1007714,215455,509877,710903,93831,79656,223416,831401,151817,864803,848013,211515,234809,388618,843392,577227,228801,1031220,82764,39748,397819,392162,542082,492798,1030863,1022670,25481,113191,630066,453829,31547,494658,397167,223763,536403,432327,464963,875735,426643,326988,563866,796404,806919,722009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]