SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463254 LIMIT 1 [ RunTime:0.001803s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463254 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422404,590941,244682,842124,687006,365424,131608,30543,294088,809627,461742,810782,744683,471124,207648,642125,382661,88358,765495,808382,575668,317292,294503,204905,849465,116972,712033,950814,223142,1047767,632257,436814,596034,417376,243572,536623,92387,541759,152124,78856,510010,950516,121982,11415,803270,789640,585812,838206,197452,756723,893838,1002923,480726,350349,738124,537853,612496,408267,970485,759514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002416s ]