SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313684 LIMIT 1 [ RunTime:0.005188s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313684 [ RunTime:0.006720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047691,991085,215221,974822,836686,494188,410775,121112,657917,157463,415566,904111,853592,736860,452083,804656,638123,874432,8220,529618,219008,128794,910040,144514,970018,1048495,271554,586506,291774,702388,670985,679197,153113,569785,386175,692445,402792,906149,163378,49334,418869,1011521,987730,1029944,651847,522524,694955,809088,264216,588272,361236,434580,571586,318714,818361,796022,627361,1039783,792570,826906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002549s ]