SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431715 LIMIT 1 [ RunTime:0.000839s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431715 [ RunTime:0.002605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711805,37733,1042896,127502,882527,1031274,943522,970546,324802,813118,397496,260685,879187,812761,669617,994073,563377,878791,235854,242281,434077,324814,792589,251190,802853,260904,125149,993163,145996,592953,236345,962915,492513,541269,96935,538221,474600,573813,1009531,839951,927392,53509,710644,310684,635763,221843,492453,433123,507526,323477,1036799,957763,566268,892599,1015959,653799,1011140,1036400,363611,357087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001399s ]