SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561310 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561310 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246302,582214,443315,460497,268352,327362,364802,36626,941902,733352,573842,252590,979169,290735,948582,93148,233979,122211,621742,520321,919031,520117,52852,953349,60712,345564,637891,744157,657327,905388,905943,1019919,758343,581423,207158,700235,285022,913857,872720,907773,513403,104920,684914,846519,929895,1001572,854056,799338,135529,860064,562908,389128,361691,857052,735838,290545,226073,855798,737166,659829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]