SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497943 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497943 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392003,928223,912152,496234,936066,715254,913605,185662,188860,744029,155021,321755,846765,64288,789820,297409,811953,810134,414115,848300,781087,823688,383516,127207,293311,132456,832678,88290,719413,167867,238946,643327,282717,137590,925780,598958,401427,805945,631963,279022,395186,558255,483213,171925,492620,106699,801298,143248,28075,868715,837350,473531,62455,764554,639752,1011279,545651,628251,585131,1025434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]