SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531959 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531959 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311217,53259,399151,211892,167901,594104,269259,679191,813825,470010,410857,289093,641491,116976,704120,598862,283520,895634,38241,877816,814144,162763,358528,149218,216778,804828,1043915,593944,961601,243207,344152,738421,852313,354878,307492,877801,619043,576184,383593,664922,138011,84425,799128,735077,349862,204323,589785,941999,19373,933272,912291,211932,565428,348917,1040646,735168,725533,882584,267789,1019580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001000s ]