SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201380 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201380 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429777,578547,260210,452110,863819,652754,480936,509649,103894,697991,1012039,86335,592929,90075,257702,524533,314720,356939,115729,243241,875074,690953,531442,835597,184590,129705,694924,703010,725249,1041966,503532,875182,686348,931811,802211,388985,697217,629093,1021881,466877,750541,278885,678456,2651,281514,812681,127151,1012627,866167,591280,331407,397068,370965,121946,18046,288190,895900,775538,969364,151418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]