SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399064 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399064 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759348,699655,256719,738290,684301,109778,70514,234581,811055,598111,410050,138943,212723,492872,1035712,652714,3397,36558,512821,224069,495787,264452,234238,629034,305543,504345,788864,105529,802990,873706,509934,588704,318268,905002,554423,862690,731689,365320,544968,649613,143972,182468,886571,374330,452784,912039,118256,292082,374596,776286,1005954,1005956,784239,172283,948704,403815,967929,488456,729090,360306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]