SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474088 LIMIT 1 [ RunTime:0.001277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474088 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574262,401398,751082,995475,66816,32435,224393,454902,919003,387812,891685,145132,41467,336969,418228,140234,95588,56528,542792,791373,140346,747037,399255,301175,769869,1002182,888885,319001,896239,667009,154435,106472,1001966,686040,421028,108929,8616,189586,382654,45904,304415,616763,249278,168725,143914,524732,406726,358006,178444,849979,513363,427807,509633,1039229,957067,875951,890552,536121,293275,695183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]