SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504535 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504535 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665111,770324,1909,685872,897496,67111,403510,61466,387477,199697,426472,864917,729021,1005966,666757,702287,920343,215471,492495,209983,611135,381811,839574,790633,51552,449040,359645,340448,992688,795533,430879,989237,227979,858271,88657,990461,319346,890034,23718,368125,900793,400488,527879,77771,162794,687941,878404,454203,612558,735742,449064,648265,409394,175864,30478,609834,986410,683652,332714,977880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]