SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508011 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508011 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343110,412809,192593,743314,717954,278994,905892,1017580,773741,189261,844036,422818,483088,749463,187855,804647,38737,1041943,119947,1036087,532582,359811,33548,536969,205869,1024772,1016344,462375,122623,288617,651434,37033,120918,937763,76482,221842,132439,285400,386488,81579,952430,414231,873721,20368,851171,61356,203005,856349,976862,368423,736365,280208,213306,686141,907804,8792,17193,849006,112740,186822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]