SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 839804 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 839804 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619389,178705,470371,957795,231493,719343,168187,740347,981441,922860,235470,351384,18354,143707,326501,979383,918036,1031738,619027,480144,510697,352472,612885,31198,952944,47578,582219,392662,780265,838467,573033,571785,578705,425807,832260,422358,149811,53145,213084,606832,134209,16684,183139,767387,968697,799276,11824,956463,53756,222517,726242,720449,445222,918636,518252,375357,863806,88634,125459,882914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 839804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 839804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001190s ]