SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041470 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041470 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387214,271124,992056,1022164,624698,826079,274666,631744,185366,109413,894092,709952,116829,460402,15148,668876,88830,742367,130316,374799,9647,925833,757465,143670,882346,644029,200617,295189,495067,343870,470884,590870,903725,45640,855140,215172,892723,694976,66708,433770,723908,672622,455284,51536,219630,542122,96169,824922,152936,438702,879506,268086,580313,29340,859352,399906,489269,311044,457583,301386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001756s ]