SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429543 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429543 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697483,1039064,642763,649427,475628,81690,574408,492876,39472,638240,554683,1047073,642648,564931,528266,141588,905729,752398,471898,105991,503795,751923,714954,738496,359221,489550,769745,525646,686024,286737,292594,109829,959313,104826,599724,436989,988071,730086,541871,353793,78867,84909,270209,464849,154945,670084,745965,413147,579916,582728,607464,962039,847188,897130,918830,710001,178796,986542,407553,785720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]