SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526836 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526836 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103390,151444,105548,139608,472694,42868,237365,28089,647299,972614,1011750,200425,102238,726537,383653,437704,368866,241929,1044839,290037,303539,371055,427771,847542,310441,236408,155768,221289,1006096,433101,116125,245624,342614,978211,677980,1016271,416921,217035,587239,744747,164146,82770,461657,906660,755062,257589,695961,211172,116126,222345,46407,916444,80626,477757,835405,126525,382232,951033,312289,159351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]