SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011495 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011495 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196813,271769,614936,1043425,234612,312316,353441,606800,162767,354375,716169,1018671,244001,932037,58022,498203,838700,857270,1002154,772947,71625,504820,76423,73906,205,968020,455117,362549,406450,256857,532322,881911,870188,258993,543768,70416,77948,499039,670349,365664,753453,234571,209206,373279,334023,820376,919855,866030,963120,493161,1036830,905535,448192,14156,324026,299702,650098,810903,800583,877577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]