SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506911 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506911 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637057,10869,879942,1008258,663049,588758,84384,890568,1010906,800303,175125,643677,847974,823059,565885,1023025,861014,663493,320006,547381,425122,823685,195912,441226,873137,922592,912508,459392,244880,1024006,157842,657994,846934,90085,920032,25368,553872,592034,495735,991480,689670,771222,122118,947477,1041794,934762,933163,208384,554009,253612,49128,755730,429082,60515,225248,668442,740535,317971,966857,947456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]