SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545206 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545206 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752250,838804,987539,40722,158510,1715,623346,230542,801009,439052,740498,213538,322678,865446,964771,13242,479994,528663,870131,475831,238983,472495,542250,188183,978299,291015,721524,469185,986691,889450,963494,239801,740375,347324,373575,607823,764279,258546,265392,544684,681622,604300,36611,719772,890135,940406,386282,491004,2528,5828,1003269,294625,991843,631585,661773,526763,138497,785418,877775,378583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001987s ]