SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002884s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021154 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021154 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266241,381663,381602,798724,1031332,38421,311811,308400,339498,501900,115134,858716,656324,571908,1026603,601379,734445,88630,545303,776340,381620,73507,748301,1038683,532779,602779,935593,982771,832195,394862,951668,210336,981606,810965,1019207,248591,1027562,315939,425561,368869,695345,928187,917860,201574,199134,66227,736128,453233,928862,914936,856326,88768,480253,558978,64905,778891,207241,767373,161812,996289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]