SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691473 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691473 [ RunTime:0.003616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4857,810749,1021205,13920,543136,529371,1040073,316878,752956,516805,107917,310375,302900,623776,393974,1043176,450793,248320,496565,946853,682346,912289,412441,410912,200214,321029,154443,302589,149940,480535,850317,230801,132320,542786,161319,709697,607137,580466,784861,66715,435085,562381,310399,862240,570325,941130,1038697,720726,703826,624576,513078,525569,105307,995919,276959,998911,642126,745605,564100,468852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]