SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026445 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026445 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204751,185866,49548,762512,442723,113357,334227,137859,262414,418627,362292,765359,164188,1036146,512911,928150,600919,343194,140518,138759,227896,572706,386351,798785,147325,16398,771110,841096,859328,204490,883725,120639,40223,782522,1023214,771767,881156,403301,847574,340263,1027893,947473,746131,280993,930128,957247,639682,109624,458581,190378,341605,261368,1004138,882861,950295,387819,110088,104613,638047,992297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]