SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291860 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291860 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411297,809937,875071,284688,307705,1018203,646892,914212,955000,142834,818716,75821,384315,266266,584403,4496,169365,837864,449987,376368,268589,965799,909067,173898,598358,731724,38521,388773,313933,636278,457225,862455,823114,801004,106729,971414,444677,1008007,892051,20050,31796,225563,803632,224344,520850,225756,669317,378956,626968,687021,203721,939433,251840,1033775,741334,918936,306016,362219,195843,130341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]