SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982841 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982841 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475503,287910,487330,1040929,837623,676210,967920,917212,849238,12976,133810,961286,863261,682407,32091,108540,353692,852037,229137,732052,278473,469835,927688,875024,289027,861684,381571,294321,20097,376805,1002956,880274,246279,641424,522079,162644,338731,241358,361356,198148,987848,841380,81472,1040835,331427,785525,310931,753251,735996,301422,825852,288803,600167,452840,108857,317785,405440,126272,1001557,901772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001194s ]