SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299523 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299523 [ RunTime:0.003404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410842,832738,25661,265855,345321,120902,758947,27654,194119,676658,672644,408581,793867,782858,39556,501013,955552,937488,959353,575843,955996,299918,871610,343963,490159,306547,468631,240147,279912,758652,209525,2447,534218,151027,1005008,982448,966705,1013863,668540,755216,88960,534331,781926,721611,721384,31714,582620,504155,939543,359271,189601,536925,190674,282193,868560,736097,760716,1030350,900406,198139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]