SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631191 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631191 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912951,996118,746646,342075,565956,1010182,903220,14199,380400,809319,682494,289679,292829,40822,978251,597569,501145,885375,651173,106899,183862,47757,192230,355625,1008192,683320,813727,679194,715450,28129,535854,457242,729205,424325,79368,814344,582660,763808,988046,661213,492034,985391,406599,194590,830499,235000,965907,235565,10495,26589,422845,455897,159999,131707,772839,95699,615111,413958,636154,390937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001839s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]