SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042451 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042451 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273958,776424,243426,445207,113836,118579,38924,190757,78239,747817,520302,355859,175022,874334,135056,534886,463563,720330,19680,769006,633797,874707,341508,597916,108029,870308,979691,134826,156556,80903,18718,664924,134226,928586,66012,348482,305454,974584,773427,246,523221,490009,362120,646707,10400,533141,1016346,273134,149423,704121,414082,173729,665587,671301,541414,556095,691756,630659,457957,397099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]