SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50280 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50280 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598082,110060,527185,300221,753263,107594,863458,788934,328511,422588,5867,291320,757347,317509,547871,684498,380356,784099,576688,844924,948905,3790,348014,161223,525330,457219,193128,313316,46141,962302,262495,820568,627177,988432,250259,343647,1036199,558140,451361,1005805,814227,32144,846751,812630,562104,655427,484194,320289,564090,265487,907261,854906,198828,1448,918148,367435,1033569,365013,296051,477332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]