SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143896 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143896 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497320,598788,95515,177563,521424,442471,704741,507416,292792,416510,73509,221123,1037918,95722,728816,630474,677660,513028,383382,786066,106571,364312,555919,480470,997910,370135,891571,475921,491663,67243,313239,392521,984551,732064,324060,176353,258301,285283,675576,789,1038120,591486,330373,719068,327615,147418,182106,936983,785947,926555,842595,70058,374729,39101,456952,509300,820941,926817,64929,628422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]