SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315639 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315639 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180639,737316,192019,1028602,929541,579813,788730,66489,636736,509857,828005,1026398,939143,901979,1028742,636398,388080,231959,717390,13765,800050,289585,496335,176654,190068,389611,94627,272044,759899,639768,58258,670801,233721,549257,263487,432808,342564,697248,187659,974265,449333,353923,551484,563443,344681,185642,952098,238237,964336,893029,715948,48319,352534,676980,967847,146599,748821,158818,539058,740214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002965s ]