SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497908 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497908 [ RunTime:0.004608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54814,827735,318141,369111,672466,942031,658091,209851,699918,581693,511405,326617,837910,207790,92295,959856,915566,150837,269934,1001813,882974,588558,605888,852079,737257,379330,374646,866041,359072,373504,336906,403086,559835,822453,1043868,662064,807383,718587,44970,416984,456103,638898,772535,789838,110301,718815,942959,210637,737207,75770,1011631,818778,1040572,892244,335514,908276,70445,490743,131631,192714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]