SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000681 LIMIT 1 [ RunTime:0.001256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000681 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214212,647067,280145,862590,744007,408790,769493,140269,332487,959226,809316,380139,551515,697515,927004,847521,736954,278041,10581,19552,984981,400671,405111,1409,617726,616208,344386,740234,954859,812143,551169,475384,819531,793734,91737,219858,604007,1007037,802993,875308,158655,720635,522396,339016,832011,462627,544747,931929,130338,577554,833035,892015,144894,188315,28839,966758,749987,39427,142164,829231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]