SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474941 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474941 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319675,1029869,775450,510848,7901,665473,981729,967037,378329,989622,615411,160441,349700,211649,43163,756488,673652,156568,536427,195167,628318,244972,4099,615701,482877,988691,32418,834472,192813,198321,902458,412131,806019,26717,312766,42548,444951,217665,655721,528931,150481,315317,392352,336506,627038,875100,848181,848802,979735,440036,608647,520978,462390,318486,18395,2241,692460,332206,73178,969266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]