SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038321 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038321 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43177,902863,470401,171722,885753,709637,19603,422766,663282,649711,489923,866458,854823,317705,856832,803291,873198,586440,552344,1046472,317945,38008,263091,444033,754918,186500,851114,268293,424671,950988,225016,1016641,118813,813741,1030122,715579,830157,958581,36688,250698,86279,89691,735035,433843,46994,424061,133567,686720,141571,288415,1018078,935630,364327,715515,169290,222848,27952,660302,891131,794922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]