SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101428 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101428 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183641,88268,211315,978965,121203,903487,1006259,199796,912672,312390,94419,446619,718093,417029,219918,645700,590340,144954,350846,56099,681596,374352,49823,183907,721922,397111,434377,282916,624471,341728,264872,146356,177213,470370,773623,285207,758516,299611,632239,319881,947863,735531,632035,544480,571983,655318,577114,279088,891883,712572,74070,565313,560642,595486,595653,1022863,673557,300029,235372,24146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]