SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368004 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368004 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141371,248972,634991,437686,713317,774987,260428,1046120,214859,381197,101099,93349,536359,130225,633060,602809,380481,728420,165114,738161,702810,905396,689813,720395,624797,835452,452796,108358,420647,938773,1016542,747919,76796,845663,125499,260758,26961,777507,687182,457566,80511,729202,272077,9181,982059,601226,657870,42871,108937,974717,383447,776999,18432,720782,608860,118703,123181,513349,975691,686766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]