SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54431 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54431 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39591,386685,32130,1016048,797956,577299,837995,1028067,746633,826406,425585,842232,992094,861652,618988,980684,1029572,614449,165459,327658,541828,141866,1035238,817892,669605,891296,891831,877526,1011355,743338,144911,828135,851511,1008436,920658,871341,93084,137687,109693,539968,5294,626448,428197,73761,727838,550132,60829,617633,393646,973634,547727,702958,290671,486820,351742,542829,427830,822400,691144,789040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]