SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541856 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541856 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940801,387630,256574,709759,1026484,114207,513837,972907,803833,862625,426457,227831,236558,72621,805503,515211,871586,177800,357060,555262,581472,773935,620467,472943,578944,719849,591298,448504,950089,202204,460085,130529,396369,240744,886367,633674,48565,31683,534016,301662,662620,204422,305386,170861,693823,33826,753669,571409,533682,585012,273504,892501,683438,666529,268973,106802,326896,9509,135319,59432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]