SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516612 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516612 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537492,53309,163097,825419,629889,704262,224744,337237,598278,358635,597266,584320,562825,506896,1000963,939156,248309,1001350,932639,231561,535051,813772,716855,308732,552672,506342,471111,728608,242720,235267,540704,531667,669695,987110,139280,746103,978273,496999,662956,947882,599543,130721,182458,713349,583234,330404,292966,909886,246894,587472,287679,978072,336096,563234,788808,930297,493265,553691,231762,185777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]