SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145681 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145681 [ RunTime:0.003363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52953,101532,315409,225470,222271,883715,977209,442231,742761,700133,495310,532091,367237,161070,861447,278044,840228,978181,333722,445438,463584,570237,525745,539862,226230,483609,22330,618837,314041,888879,602785,212115,981672,870234,1036884,900069,355233,978595,972950,809446,134157,537858,230795,64379,1008720,664333,476272,36490,126067,705874,792418,28642,465175,284572,292155,685586,798226,987997,24756,1014927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]