SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414957 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414957 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488196,433441,741293,526145,979188,526882,751206,942414,266571,765977,167760,619916,192880,852000,692602,554290,650450,92856,793737,203175,575439,553538,782231,941781,385175,66893,291381,925139,532812,560283,971050,297610,184156,946420,842183,221797,194928,707107,437688,811459,254626,215031,559660,452234,967521,957823,322448,766695,1000474,323076,699201,293190,488542,103495,429811,842521,1010855,813820,899343,549883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]