SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681507 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681507 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796133,185993,727565,162457,253147,363031,111346,341166,985103,117059,800683,671868,315269,846350,26295,755766,367610,377628,471478,634264,364933,267665,349950,297100,634960,418744,106047,718122,353011,1032568,445665,929953,891498,109844,418693,279096,804394,197379,122107,463666,557404,744203,52492,634315,591319,907460,226753,624007,1033814,82845,845781,936070,1022827,938016,277167,1008932,526565,826793,148683,151471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]