SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019540 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019540 [ RunTime:0.005884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292016,935395,752077,449497,575093,431174,335894,995073,917554,834947,67455,540639,235233,20620,64165,169685,592697,639820,611837,803827,739333,648817,480289,926424,59772,467660,745078,116622,257059,242184,10929,524743,496358,291302,96691,360441,117749,187228,960905,260121,817963,892566,1014441,875548,650682,545332,851097,635025,91042,871327,106471,413389,31878,224231,327077,749271,972147,394815,1002064,335197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]