SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503615 LIMIT 1 [ RunTime:0.002504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503615 [ RunTime:0.003604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783405,144113,263181,845486,99704,351284,298096,458601,225802,876657,827324,484476,789223,513239,523075,274916,465948,740341,680591,714084,51453,676559,201032,370167,337268,42968,1034660,301897,400135,637005,775783,704187,793919,495230,931573,374843,4533,331190,627324,496385,977716,909538,964588,567319,260324,833113,397454,948887,771202,693282,652855,286675,634570,38514,227209,860774,542231,514505,616022,930937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000749s ]