SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 15029 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 15029 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036493,520127,603951,149881,1031187,342571,397512,115975,915951,603170,568042,375160,742152,539130,400533,1010444,505411,529500,387294,480978,813697,260243,381850,292699,280373,585882,1002124,1047651,904111,721734,301157,25392,687037,404120,513057,508006,898684,21380,1025497,572783,45698,147870,950535,389763,730545,1017321,946786,217589,574339,308295,471142,21648,1022008,935856,19724,454311,458361,915267,672892,190591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 15029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 15029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]