SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031476 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031476 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201006,165798,259111,458224,148941,131727,327316,689279,344638,1048007,599367,528410,214211,949115,367604,191281,433100,206148,643461,636292,128186,171,974960,739781,597331,19553,736470,798997,788655,624766,837859,571518,228959,751336,572506,669002,279193,123563,525881,412486,760640,523833,657572,152676,312808,675212,813350,514609,227844,967854,434795,44210,571672,305055,6959,1020503,830536,301261,716558,142588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]