SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102832 LIMIT 1 [ RunTime:0.002140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102832 [ RunTime:0.002729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528761,384109,267248,99547,614965,733590,839155,221688,625605,965353,608872,343944,383399,681936,283075,194208,264481,899031,445336,1043808,855328,436250,477038,805322,629900,900828,296468,985700,787892,423183,201704,1035489,670225,203667,730211,544839,352357,228475,150017,505491,172798,249990,210953,413565,256994,472630,40204,998743,606457,803893,261119,136460,624417,34650,315724,291245,514560,633828,25400,399642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001282s ]