SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502744 LIMIT 1 [ RunTime:0.002054s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502744 [ RunTime:0.005598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935352,149341,401055,395901,34057,821011,753634,951311,715222,467768,728557,703412,802565,184311,390910,126615,586153,28713,371973,344475,394672,440405,563322,696739,139126,282481,915189,490840,562740,973976,329651,47940,348840,310258,449402,804504,954815,114738,576688,223245,281876,944697,537339,684111,882523,82728,804771,126609,994684,334459,1000543,406026,247669,785308,1011012,304698,663968,712697,271496,506048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502744 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502744 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]