SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410210 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410210 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264962,941716,841583,674924,785201,820095,321923,72053,206603,383456,123369,194924,450788,363996,174347,808203,191290,115524,483163,1032344,515605,479184,711961,808712,110258,23974,693309,357602,1026465,414913,578277,462287,959216,90201,457182,799220,324462,173994,382878,246062,155970,309224,642470,156057,913857,47904,683949,997324,325773,480623,816347,1021196,774978,984244,433198,857140,152394,944252,687864,733299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]