SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490940 LIMIT 1 [ RunTime:0.002009s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490940 [ RunTime:0.003189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91849,552920,998736,358783,810888,359565,288601,459409,663081,26437,673258,751621,364317,297343,24586,592896,867308,923846,639806,935538,101064,727836,152548,1013924,91222,516560,32378,157851,857163,70019,772218,118540,175428,644171,358474,690954,719788,553620,684509,540483,660124,614680,684366,869227,429149,962441,221406,138100,747062,634238,740280,988652,916811,152813,863193,995008,319088,1025568,476601,893555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]