SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296422 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296422 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318820,36250,764063,196255,71211,643218,1031768,937582,772516,500810,910596,371077,431348,952060,508397,242530,800430,396967,701958,541273,82978,983319,424711,461614,486279,3027,344247,186183,850140,390536,457057,436400,104439,130933,814534,752134,500453,462451,444454,585064,188751,703018,70576,814037,957054,457089,349629,138077,848346,682407,774621,238553,26030,410399,278802,499317,298063,12228,532853,87990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]