SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023478 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023478 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914729,972065,922462,324015,374221,216244,599572,541488,357477,845062,31508,640144,337354,823527,231643,605855,550693,437588,566156,433300,124334,833782,569083,204049,187777,98356,766074,1021902,371160,736289,393377,801403,1231,230678,132854,1040700,51813,50601,199262,846481,261346,877171,563495,764895,391750,926283,864025,170132,760711,864130,305661,364773,463695,282775,558120,974411,399721,3690,619983,455000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]