SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005889s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027856 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027856 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934413,132151,618236,1035524,298698,957039,119069,377855,434241,515754,881443,612500,310859,689169,567731,351333,748817,763819,993921,353348,221185,994647,180237,833954,723622,612426,324940,853772,394814,417899,836644,772904,86545,477692,186775,70138,580215,817571,145516,600110,361944,853925,66397,284692,305790,1045784,737891,1015812,633553,449011,667841,569226,647158,553738,674861,603098,645486,356925,31646,464439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]