SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461973 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461973 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331190,92457,842260,487717,141427,902831,617388,142573,576992,507171,1035988,183582,946585,243545,76656,107711,64847,486055,766213,1023697,113238,957106,380937,292884,442243,599061,702835,897372,305610,806030,459277,4179,886219,189855,83100,277832,477548,981066,184308,405835,310085,1009795,4639,469500,441221,871795,813545,103129,387371,52325,239037,141613,249743,996820,1035495,1018039,159321,1042978,798467,157631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]