SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38204 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38204 [ RunTime:0.004978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286785,833468,481409,517505,960540,401492,355717,468549,436026,1043508,208074,254843,99395,529992,893004,924284,19391,213115,813147,72906,436291,307051,193408,45270,682027,150977,82310,557999,243145,615969,434667,301962,940868,893961,847529,707924,803943,304007,53464,785366,127722,661674,18637,763915,487639,616157,736651,501086,415835,389401,647466,6298,253006,6605,173267,309888,22509,428472,248753,99197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]