SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201266 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201266 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559418,61042,73656,719305,595281,267581,600234,693406,1011161,827931,32194,609712,1038685,530517,382805,323650,287891,958631,707990,289130,376185,165850,540246,1028741,646396,68399,10192,507889,797668,985699,109549,968505,719588,995251,81569,925031,98176,848403,1003234,840439,905329,1031637,800490,193634,401867,262848,224377,308017,357128,164553,167320,498606,626153,699741,480869,576811,644033,958185,925480,6743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]