SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532680 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532680 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581781,111403,968101,265947,752002,969451,949239,269813,790278,236348,21721,633599,204532,266976,232094,332785,945509,840754,732804,511181,390761,305721,796737,240698,534942,979341,354052,493695,320789,620395,814475,897446,1027573,106969,982123,70667,226919,682119,742075,793038,350756,7861,923516,76886,875672,859508,769244,399051,838296,832271,331673,469862,302896,105933,169923,301207,234788,81083,67661,760238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]