SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010846 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010846 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992776,751684,1040334,521369,935949,938918,300413,839722,934486,490086,942726,651682,578092,294914,370090,755876,143444,815225,295968,568737,579540,227327,446666,956833,908638,173355,635356,665122,594851,829412,214009,637684,82959,795702,968039,882562,359401,285948,679773,312728,524108,16745,596968,818309,453430,1048161,977736,580637,160620,146845,366954,928270,303136,539295,915862,399513,774884,226743,382760,627466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001389s ]