SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414963 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414963 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233692,593217,727788,421342,454426,855630,787203,404932,749529,296128,1025518,542436,824738,443024,824165,394550,496280,681426,492251,475000,451450,73029,315609,899558,341374,707065,689279,892218,51771,659681,421399,536460,985900,198370,978491,128854,845345,758086,46388,452307,936343,874454,699714,303290,126475,1042465,570572,921760,885457,980349,969151,764363,405945,361195,164079,732297,657198,1047503,738342,952923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]