SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323216 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323216 [ RunTime:0.002771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201333,36568,403948,344944,485061,531546,218400,970298,454047,859976,802723,19006,306817,102570,140526,354653,1001581,474927,248659,108716,984956,635810,152652,660899,1007702,83989,365366,867007,1040796,49106,757419,97707,345219,534693,306092,161638,583581,1041507,741337,604721,997278,910495,452906,155508,640490,736283,500972,528481,388485,1012743,166579,934942,15904,82188,906172,907193,658004,623541,713383,579779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]