SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473293 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473293 [ RunTime:0.002624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598596,573124,673642,782416,934895,366402,824675,563128,1028625,198078,445587,666382,800530,545393,539196,106120,207822,458420,135813,930584,836002,734195,1034940,740726,835176,583815,391300,1020206,357650,976021,17493,675501,939041,101934,369493,537437,328245,330022,529373,40898,723098,35503,978418,566397,904416,118797,584392,22185,634641,657517,1037321,812382,428887,210401,927881,331504,712632,540277,776029,288110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]