SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490128 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490128 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576872,1008367,662106,679307,1027420,161669,690978,687294,536105,930637,718426,20038,581664,315191,723650,383404,968711,843674,578463,193818,117989,754994,961250,791990,384942,968501,187144,611299,807585,643096,1011893,187025,653450,714108,828221,90643,126014,646960,556042,805593,14999,726065,724622,707111,133006,721359,715485,409457,87899,300334,251217,37518,328533,533890,869982,146690,55802,880391,712096,76238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]