SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020453 LIMIT 1 [ RunTime:0.000894s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020453 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498128,313831,791557,214905,740797,836573,718261,886061,1038958,54229,102229,459154,902052,9651,940309,392144,143940,86277,856978,346019,258809,163668,71360,510580,666488,318127,989035,152033,441130,389508,36710,433559,144434,871098,515105,585092,852907,880904,439668,709939,85291,340991,936642,313506,941351,271182,845692,888514,507005,692169,1006818,503519,750154,838955,168848,628679,926441,848796,988196,538907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]