SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044855 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044855 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198013,525832,637246,373952,170031,70709,182127,102970,989514,869184,727834,248976,73632,97456,445903,51716,659945,468892,482134,642306,241773,23352,848633,851194,601703,519920,345171,3301,437086,302057,796581,846133,486042,777631,141969,125087,712144,557896,1040498,362559,229550,303852,993949,267811,638679,893449,730061,331035,505518,246141,106885,519800,939125,586710,64518,920996,240421,375174,839673,705325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044855 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044855 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]