SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002708s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191813 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191813 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280733,135331,1043647,586188,627320,576916,172389,173962,783460,627044,190570,1043686,399603,70498,363619,36342,125762,932078,835737,585539,356599,355642,146894,383519,540,999906,761844,503012,201953,141205,535183,184073,470744,647105,831749,266059,698745,135812,694292,1038493,629924,156028,217324,523626,678755,16207,133981,149648,962585,900195,252450,800977,686606,676190,773230,475354,1033291,784017,302449,304030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]