SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345401 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345401 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612988,588316,127331,747420,499884,642129,890836,871437,342149,289233,1007309,398617,969918,381714,259009,225229,792218,967688,761503,218051,813471,639253,887406,706085,792439,367588,784796,885836,455679,328522,496458,49470,676129,30761,841006,706195,784865,151127,944509,978111,325252,166439,728321,1030959,176572,219995,327660,837039,398221,94003,566675,530221,930865,789794,332211,391993,388607,556474,424108,391420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001085s ]