SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105104 LIMIT 1 [ RunTime:0.001465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105104 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328571,811152,258845,930480,192805,619620,221623,629981,129781,700644,875914,346386,665339,375565,761082,162390,78327,545391,583501,448212,990602,64756,942784,727956,542233,264336,37399,294194,559297,399400,31673,134720,334648,928759,764706,508281,882171,273568,682729,673731,341463,793562,858947,864340,339962,528310,430487,959858,488312,463873,700415,428246,236201,542658,240278,976351,272838,27732,496587,364169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]